Posts by murillo.r27

murillo.r27 · Feb 3rd 2017

Re: Copy Certain Columns to Multiple Sheets

I want sheet 4 to contain the appropriate info from the master spreadsheet. I am also updating the master sheet so I need it to auto populate to the corresponding sheet.

murillo.r27 · Feb 2nd 2017

Hi,

I have a master spreadsheet ("Sheet 1") containing data from A:BF.
In columns A:F I have data that needs to be copied in all sheets (sheets 2, 3 and 4).
Columns G:Q are specifically info that needs to be copied to "sheet 2"
Columns R:AD are specifically info that needs to be copied to "sheet 3"
Columns AE:AV are specifically info that needs to be copied to "sheet 4"
Columns AW:BF are specifically info that needs to be copied to "sheet 5"

So, essentially, "Sheet 4" should read data from master spreadsheet ("Sheet 1")like:

A,B,C,D,E,AE,AF,AG,AH,AI,AJ,AK,AL,AM,AN,AO,AP,AQ,AR,AS,AT,AU,AV

I hope my question was clear enough for someone to understand.

murillo.r27 · Jan 10th 2017

Hi I have a worksheet with values from A2:L100(and continuing as I input data)

I am trying to copy an entire row depending on what is in column L to go into their own sheets.

For example, if in Column L I have red, orange, blue, pink. I want the row that says red in Column L to go to Sheet 2; anything that says orange to go to Sheet 3, etc.