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 et...
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.
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.
will 5 people be enough of a sample?Riny_van_Eekelen
- how do I attach the sample file?
If you don't see the option to Drag and drop or browse below the editor,
you can share a file via a link to OneDrive, Google docs or similar.