Excel VBA code to copy data from several spreadsheets to a master spreadsheet based on a criteria
Experts,
I have an Excel VBA question about copying data from 8 spreadsheets into a master
…![]()
Spreadsheets
A spreadsheet is an interactive computer application program for organization, analysis and storage of data in tabular form. Spreadsheets developed...
Read more- 7.3K Content
- 2.0K Contributors
Expert Spotlight
Developer & Coffee Roaster
I have over 30 years experience in Sales, Marketing, Technology and Developing solutions.
Troubleshooting Solution
Article
Excel - Did You Know !
Excel can be a tricky bit of software to get your head around. Whilst you’ll be able to eventually get to grips with the basic understanding of how to get by, there are a few Excel tips that not everybody will even know about let alone know how to do.
Video
Power Query in Excel
Viewers will learn a basic data manipulation technique of unpivoting data in Power Query for Excel …
Post
Oy... You ever make some changes to the underlying data …
Oy... You ever make some changes to the underlying data columns in a spreadsheet and then not …
Troubleshooting Solution
Use keywords to indent nested structures in Excel
Attached is an example Excel spreadsheet with syntax similar to a table in a 60 page word doc. It …
Video
Pivot Tables in Excel
Viewers will learn how to create a PivotTable and make basic changes to it in Excel 2013.
Troubleshooting Solution
I need a script to take 2 hours off a time in a google sheet cell.
Hi techs,
I need a script to take 2 hours off a time in a google sheet cell. Any assistance is …
I need a script to take 2 hours off a time in a google sheet cell. Any assistance is …
Troubleshooting Solution
Comparison of Values between two sheets
I initially had the code to do the following :
Compare the ranges between between sheet1 and sheet2…
Compare the ranges between between sheet1 and sheet2…
Troubleshooting Solution
Show current time on separate rows for each time zone
The objective here is to be able to show the current time for each time zone by putting the time
…
Troubleshooting Solution
Trending calculation spreadsheet
I have space available numbers in a spreadsheet tracked over time. I also have space used numbers. I…
Troubleshooting Solution
Convert col/row reference to heading/row reference
I wish to replace the col/row reference with heading/row reference. I have several worksheets using
…
Video
Tables in Excel
Viewers will learn the basics of using Excel Tables, the benefits found with them, and some …
Troubleshooting Solution
how to calculate number of months that falls in 2003 between two dates
how to calculate number of months that falls in 2003 between two dates
lets say that my start …
lets say that my start …
Post
Keyboard shortcuts in Google Sheets for inserting a new row:…
Keyboard shortcuts in Google Sheets for inserting a new row:
In Chrome on Windows or Linux:
…
In Chrome on Windows or Linux:
…
Troubleshooting Solution
How should I solve the problem Microsoft Excel is waiting for another application to complete an OLE action?
I already followed the advice here, but even when this setting is ticked I can't open any of my …
Troubleshooting Solution
Convert pivot table text from SQL in Excel
Hi,
How can I format text to values from a pivot table ?
Here's the scenario.
I accessed an SQL …
How can I format text to values from a pivot table ?
Here's the scenario.
I accessed an SQL …
Video
Conditional Formatting in Excel
Viewers will learn how to apply various conditional formatting in Excel 2013.
Video
Slicers and Timelines in Excel
Viewers will learn the basics of slicers and timelines for both PivotTables and standard Excel …
Troubleshooting Solution
Excel 2010 - sum total in column based on date
Attached I have a scrubbed version of a spreadsheet I use. What I need is the following when I click…
Troubleshooting Solution
Automating consolidated xls files to email
After individual consolidated files are produced, these are being emailed to the associated sales …
Explore solutions and more
![]()
SpreadsheetsBack to the top
A spreadsheet is an interactive computer application program for organization, analysis and storage of data in tabular form. Spreadsheets developed as computerized simulations of paper accounting worksheets. The program operates on data represented as cells of an array, organized in rows and columns. Each cell of the array may contain either numeric or text data, or the results of formulas that automatically calculate and display a value based on the contents of other cells.