Forum Discussion
combining certain cells from several tabs in a work book resulting in a list
I have several tabs formated the same
I want to copy certain cells in each of the tabs to another tab resulting in a list of the names in column A, birthdates in columns B, addresses in column C etc I have 22 cells to get information from to go into 22 columns
There's got to be a way to copy the cells from each sheet tab into a "master" tab creating a "database listing" of demographic data and other information
Thank you in advance
Liz
16 Replies
LizMF59 If it's a one time exercise to create the list, I would just copy/paste the data from all sheets into a single sheet, one below the other without repeating the headers. Then just delete the columns you don't want.
Having said that, I wonder why you even bothered to create separate sheets to begin with. If there is a compelling reason to keep the data in separate sheets, and if the data is changing frequently you could consider Power Query to combine the sheets.
- thank you for your response.
each tab is client specific with not just demographic data in the first 20 rows but then it references there are columns for their dates of service and the charges accordingly with drop downs. the summary I am wanting to pull will not reference the dates of service. we have 4 clinicians each having approximatley 35 clients in their file. the file will then be used to upload into a billing program. if I have to copy that many cells manually then I have to however I was hoping there is a macro or something to expediate the process.LizMF59 Understand! Macros is not my cup of tea. I'd go for Power Query, but can't explain exactly how without seeing the file. Or at least an anonymized version of it.
