Reference to every Nth column - reverse offset?

Hi,

First post here, this might be an easy solve but I haven't found any answers yet.

I have a budget (Sheet 1) with projected costs in column A and actual cost in column B, which is hidden until end of month when I reconcile actual spending and "unhide" it. I.e (visible) monthly projections are in every other column.

I have some data in other sheets that I would like to reference in in every other column of Sheet 1 automatically, e.g. a row of values in A1:J1 of Sheet 2 to input in A1, C1, E1 etc in S1. Optimally hidden columns in S1 should be empty so I can e.g sum rows of unhidden values

Would also like a way to just enter a value in the first column and "click and drag" only on to every other column.

Is there an easy way to do this that doesn't involve macros or programming?

EDIT: added example excel file with your suggestions. They worked great, however there is a small discrepancy between the sum of input and actual sum of the values and can't figure out why

Thanks

Hi and welcome to the forum.

Please upload a workbook or a representative cut down copy, anonymised if necessary. It is always easier to advise if we can see your request in its context.

Show a before and after situation with manually calculated results, explaining which information is data and which is results, and if it's not blindingly obvious how you have arrived at your results some explanatory notes as well.

You can't drag and drop to every other column, you can copy and select every other column then paste.
Or you could use an Offset formula that evaluates to zero for every other column whne dragged and dropped. However we need to see what we're dealing with.